USE [texchange_db]
GO

/****** Object:  StoredProcedure [dbo].[SP_UpdateBanners]    Script Date: 05/29/2011 19:50:23 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE proc [dbo].[SP_UpdateBanners] 
  @id  bigint,
  @link nvarchar(150),
  @position bit,
  @filename nvarchar(50),
  @isActive bit,
  @order int
as
	UPDATE Banners SET [link] = @link, position = @position, isActive=@isActive, _order=@order
	WHERE id=@id

GO


